{% extends "base.html" %}

{% block content %}

<div class="section-title">

    <span class="eyebrow">
        ADMINISTRATION
    </span>

    <h2>
        Academic Year
    </h2>

</div>


<!-- ========================================================
     EXISTING ACADEMIC YEAR
========================================================= -->

<div class="form-card narrow">

    <h3>
        Academic Year
    </h3>

    <form method="post">

        {% csrf_token %}

        {{ form.as_p }}

        <button
            type="submit"
            class="btn primary">
            Save
        </button>

    </form>

</div>


<table>

    <tr>
        <th>Academic Year</th>
        <th>Active</th>
    </tr>

    {% for year in years %}

    <tr>
        <td>
            {{ year.name }}
        </td>

        <td>
            {{ year.active }}
        </td>
    </tr>

    {% empty %}

    <tr>
        <td colspan="2">
            No academic year configured.
        </td>
    </tr>

    {% endfor %}

</table>


<!-- ========================================================
     CURRENT PARTICIPANT COUNT
========================================================= -->

<div class="panel">

    <h3>
        Current Participant Data
    </h3>

    <p>
        Current participants:
        <strong>
            {{ participant_count|default:"0" }}
        </strong>
    </p>

</div>


<!-- ========================================================
     1. DELETE ALL PARTICIPANT DATA
========================================================= -->

<div class="admin-danger-card">

    <div class="admin-card-heading">
        <span class="danger-number">
            1
        </span>

        <div>
            <h3>
                Delete All Participant Data
            </h3>

            <p>
                Deletes participant names, participant-item
                assignments, group entries and members, results,
                points and stage marks.
            </p>
        </div>
    </div>


    <div class="notice">

        <strong>
            The following will NOT be deleted:
        </strong>

        Schools, School Profiles, School Users,
        Items, Sections, Point Rules and Academic Year data.

    </div>


    <form
        method="post"
        onsubmit="return confirm(
            'WARNING: This will permanently delete all participant-related data. Continue?'
        );">

        {% csrf_token %}

        <input
            type="hidden"
            name="action"
            value="delete_participant_data"
        >

        <label>
            Type
            <strong>DELETE PARTICIPANT DATA</strong>
            to confirm
        </label>

        <input
            type="text"
            name="confirmation_text"
            placeholder="DELETE PARTICIPANT DATA"
            autocomplete="off"
            required
        >

        <br>

        <button
            type="submit"
            class="btn danger">
            Delete All Participant Data
        </button>

    </form>

</div>


<!-- ========================================================
     2. BACKUP CURRENT SYSTEM
========================================================= -->

<div class="admin-backup-card">

    <div class="admin-card-heading">

        <span class="backup-number">
            2
        </span>

        <div>

            <h3>
                Backup Current System
            </h3>

            <p>
                Creates a downloadable ZIP backup containing
                the current MySQL database and media files.
            </p>

        </div>

    </div>


    <form
        method="post"
        onsubmit="return confirm(
            'Create a backup of the current system now?'
        );">

        {% csrf_token %}

        <input
            type="hidden"
            name="action"
            value="backup_system"
        >

        <button
            type="submit"
            class="btn primary">
            Take Backup
        </button>

    </form>

</div>


<!-- ========================================================
     3. CSV PARTICIPANT IMPORT
========================================================= -->

<div class="admin-import-card">

    <div class="admin-card-heading">

        <span class="import-number">
            3
        </span>

        <div>

            <h3>
                Add All Participants via CSV
            </h3>

            <p>
                Import participants for multiple schools
                in one operation.
            </p>

        </div>

    </div>


    <div class="notice">

        <strong>
            CSV columns must be:
        </strong>

        <br><br>

        Admission Number,
        Participant Name,
        Sex,
        Age,
        Section,
        Class,
        School Code

        <br><br>

        Example:

        <br>

        A001, Arun, M, 14, HS, 9, SCH001

    </div>


    <form
        method="post"
        enctype="multipart/form-data">

        {% csrf_token %}

        <input
            type="hidden"
            name="action"
            value="import_csv"
        >

        <label>
            Select CSV File
        </label>

        <input
            type="file"
            name="participant_csv"
            accept=".csv,text/csv"
            required
        >

        <br><br>

        <button
            type="submit"
            class="btn primary">
            Upload Participants
        </button>

    </form>

</div>


<!-- ========================================================
     CSV ERROR LIST
========================================================= -->

{% if csv_errors %}

<div class="csv-error-card">

    <h3>
        CSV Validation Errors
    </h3>

    <p>
        No participant records were imported.
    </p>

    <ul>
        {% for error in csv_errors %}
        <li>
            {{ error }}
        </li>
        {% endfor %}
    </ul>

    {% if csv_error_file %}
    <p>
        Error report saved as:
        <strong>{{ csv_error_file }}</strong>
    </p>
    {% endif %}

</div>

{% endif %}



<!-- ========================================================
     4. IMPORT BACKUP DATA
========================================================= -->

<div class="admin-import-card">

    <div class="admin-card-heading">

        <span class="import-number">
            4
        </span>

        <div>

            <h3>
                Import Backup Data
            </h3>

            <p>
                Restore the database from a ZIP backup created
                by the Take Backup function.
            </p>

        </div>

    </div>


    <div class="notice">

        <strong>Important:</strong>

        Importing a backup replaces the current database
        data with the contents of the selected backup.

        Please take a fresh backup of the current system
        before importing another backup.

    </div>


    <form
        method="post"
        enctype="multipart/form-data"
        onsubmit="return confirm(
            'WARNING: Importing a backup will replace the current database data. Continue?'
        );">

        {% csrf_token %}

        <input
            type="hidden"
            name="action"
            value="import_backup"
        >

        <label>
            Select Backup ZIP
        </label>

        <input
            type="file"
            name="backup_file"
            accept=".zip,application/zip"
            required
        >

        

        

        <br><br>

        

<br><br>
<label>
    Current User Password
</label>

<input
    type="password"
    name="current_password"
    placeholder="Enter your current login password"
    autocomplete="current-password"
    required
>

<br><br>
<button
            type="submit"
            class="btn primary">

            Import Backup Data

        </button>

    </form>

</div>


<!-- ========================================================
     5. ADD ALL ITEMS VIA CSV
========================================================= -->

<div class="admin-import-card">

    <div class="admin-card-heading">

        <span class="import-number">
            5
        </span>

        <div>

            <h3>
                Add All Items via CSV
            </h3>

            <p>
                Select one CSV file to add all items
                in one click.
            </p>

        </div>

    </div>


    <div class="notice">

        <strong>Required CSV columns:</strong>

        <br><br>

        Code,
        Name,
        Section,
        Sex,
        Participation Type,
        Minimum Participants,
        Maximum Participants,
        Active

        <br><br>

        Example:

        <br><br>

        <code>
        HS001,Elocution,HS,M,Individual,1,1,1
        </code>

    </div>


    <form
        method="post"
        action="{% url 'academic_year_items_csv' %}"
        enctype="multipart/form-data">

        {% csrf_token %}

        <label>
            Select Items CSV
        </label>

        <input
            type="file"
            name="items_csv"
            accept=".csv,text/csv"
            required
        >

        <br><br>

        <button
            type="submit"
            class="btn primary">

            Add All Items

        </button>

    </form>

</div>


{% if item_csv_errors %}

<div class="csv-error-card">

    <h3>
        Item CSV Validation Errors
    </h3>

    <p>
        No items were imported because the CSV
        contains errors.
    </p>

    <ul>

        {% for error in item_csv_errors %}

        <li>
            {{ error }}
        </li>

        {% endfor %}

    </ul>

</div>

{% endif %}

{% endblock %}